$value_get) { $value_get = urldecode($value_get); $tmp_value_arr = explode('=',$value_get); $value = $tmp_value_arr[1]; $key = $tmp_value_arr[0]; if ($value!='') { // send month if ($key=='n') { $get_n = FixInt($value); } // send email verification if ($key=='e') { $get_e = trim($value); } // send cms verification if ($key=='x') { $get_cms = trim($value); $get_cms = $get_cms=='947' ? true : false; } } } } // conf types if (substr($send_url,-1)=='/') $send_url = substr($send_url,0,-1); $page_arr = explode('/',$send_url); $url_pos = $page_arr[count($page_arr)-1]!='' ? 1 : 2; // detect '/' at last char $page_link = $page_arr[count($page_arr)-$url_pos]; // detect page key $page_lang = $page_arr[count($page_arr)-($url_pos+1)]; // detect page key $page_id = $page_type = $page = $poi_id = $table = $title = $descr = $title_seo = $descr_seo = $page_top = $category_id = $product_id = $realizace_id = $vyrobce_id = $designer_id = $high_category = $types_id = $category_main_id = $aktuality_id = $breadcrumb = $my_weby_curr_id = $realforms = $produkt_prodejci = $division_cat_id = $products_izolace_count = $products_filtrace_count = false; $page_url_arr = $types_arr = $types_url_arr = $pages_title_arr = $products_page_images_all_arr = $types_top_arr = $category_arr = $category_url_arr = $category_top_arr = $pages_arr = $pages_url_arr = $pages_top_arr = $produkt_arr = $data_url_arr = $menu_title_arr = $menu_url_arr = $high_category_arr = $data_typzobrazeni_arr = $pages_pcs_arr = $poi_arr = $poi_url_arr = $subpages_title_arr = $subpages_perex_arr = $subpages_text_arr = $pages_perex_arr = array(); // safe page link $page_link = strtr($page_link,$spec_chars_arr); $page_link = preg_replace("/[^A-Za-z0-9\.\-_\/ ]/", '', $page_link); $page_izolace_id = 3; $page_filtrace_id = 2; $page_search_id = 40; $page_news_id = 41; $page_contact_id = 34; $page_company_id = 24; $page_aplication_izolace_id = 4; $page_aplication_filtrace_id = 9; $page_404_id = 42; $page_form_id = 43; // custommer sections $conf_customer_section = array(1=>211,212,213,214,215); $sr = isset($_POST['sr']) && $_POST['sr'] ? $_POST['sr'] : false; $hl = strtr($sr,$spec_chars_arr); $hl = preg_replace("/[^A-Za-z0-9\-_\/ ]/", '', $hl); // preview from CMS $sql_active = $get_cms ? 'active < 10' : 'active = 1'; // show all rec. if is in url &x=947 /* ---------------------------------------------------- detect domain & language - hobra.cz - lang file with conf, names, ... - set specific CSS, IMG, functions... ---------------------------------------------------- */ if ($page_link=='en' || $page_lang=='en') { $lang_sql_str = '1'; $lang = 'en'; $language_link = 'en/'; include "inc/lang-en.php"; } else if ($page_link=='de' || $page_lang=='de') { $lang_sql_str = '2'; $lang = 'de'; $language_link = 'de/'; include "inc/lang-de.php"; } else if ($page_link=='ru' || $page_lang=='ru') { $lang_sql_str = '3'; $lang = 'ru'; $language_link = 'ru/'; include "inc/lang-ru.php"; } else { $lang_sql_str = ''; $lang = 'cz'; $language_link = ''; include "inc/lang-cs.php"; } // share url $this_url = 'https://'.$_SERVER["SERVER_NAME"].'/'.$language_link.$page_link; /* --------------------------- all products (except pages cat) --------------------------- */ $products_url_arr = $products_cat_arr = $products_foto_all_arr = $products_name_arr = $products_foto_arr = $products_perex_arr = $products_page_images_arr = $products_page_cat_arr = array(); $vysledek = Pg_Exec("SELECT pdp_products.*,pdp_products_text.preview,pdp_products_text.name,pdp_products_text.alias FROM pdp_products,pdp_products_text WHERE pdp_products.id = pdp_products_text.item AND pdp_products_text.language = '$lang' AND pdp_products.active = 1 ORDER BY pdp_products.novinkado,pdp_products.doporucujeme,pdp_products.razeni"); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $products_url_arr[$zaznam['id']] = printSqlCol('alias',$zaznam); $products_cat_arr[$zaznam['id']] = printSqlCol('cat',$zaznam); $products_name_arr[$zaznam['id']] = printSqlCol('name',$zaznam); // prepare perex $tmp = strip_tags(printSqlCol('preview',$zaznam)).' '.strip_tags(printSqlCol('content',$zaznam)); $products_perex_arr[$zaznam['id']] = utf8_substr_word($tmp,160).'...'; // application $products_application_arr[$zaznam['id']] = array(); if (printSqlCol('ap5',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 5; if (printSqlCol('ap6',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 6; if (printSqlCol('ap7',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 7; if (printSqlCol('ap8',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 8; if (printSqlCol('ap13',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 13; if (printSqlCol('ap12',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 12; if (printSqlCol('ap11',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 11; if (printSqlCol('ap10',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 10; if (printSqlCol('ap14',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 14; if (printSqlCol('ap15',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 15; if (printSqlCol('ap16',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 16; if (printSqlCol('ap17',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 17; // count main products if (printSqlCol('cat',$zaznam)==3) { $products_izolace_count++; } else if (printSqlCol('cat',$zaznam)==2) { $products_filtrace_count++; } // images if (printSqlCol('images',$zaznam)!='') { $tmp_arr = explode('|',printSqlCol('images',$zaznam)); $products_foto_arr[$zaznam['id']] = $tmp_arr[0]; $products_foto_all_arr[] = $tmp_arr[0]; } } /* --------------------------------------------------- detect pages from url & homepage --------------------------------------------------- */ if ($page_link == 'hobra.cz' || $page_link == 'index.php' || $page_link == '' || $page_link=='cz' || $page_link=='en' || $page_link=='de' || $page_link=='ru') { $page = 'homepage'; $page_url_arr = array('cz'=>$root,'en'=>$root.'en/','de'=>$root.'de/','ru'=>$root.'ru/'); $homepage_id = $page_id = 1; // default texts for other langueges if ($lang!='cz') { $def_lang_pages_perex_arr = $def_lang_pages_text_arr = array(); $vysledek = Pg_Exec("SELECT item,content,preview FROM pdp_pages_text WHERE pdp_pages_text.language = 'cz'"); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $def_lang_pages_perex_arr[$zaznam['item']] = printSqlCol('preview',$zaznam); $def_lang_pages_text_arr[$zaznam['item']] = printSqlCol('content',$zaznam); } } // homepage content $homepage_title_arr = $homepage_text_arr = array(); $i = 0; // for all pages read products pages for top menu (cache?) $vysledek = Pg_Exec("SELECT pdp_pages.parentpage,pdp_pages.id AS pid,pdp_pages_text.* FROM pdp_pages,pdp_pages_text WHERE pdp_pages.id = pdp_pages_text.item AND pdp_pages_text.language = '$lang' AND pdp_pages.active = 1 ORDER BY razeni"); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { // if not set page icon use page title $ikona_tmp = printSqlCol('icon',$zaznam); $pages_arr[$zaznam['pid']] = $ikona_tmp!='' ? $ikona_tmp : printSqlCol('name',$zaznam); $pages_url_arr[$zaznam['pid']] = $root.$language_link.printSqlCol('alias',$zaznam); $pages_title_arr[$zaznam['pid']] = printSqlCol('name',$zaznam); // prepare perex $tmp = strip_tags(printSqlCol('preview',$zaznam)).' '.strip_tags(printSqlCol('content',$zaznam)); $pages_perex_arr[$zaznam['pid']] = utf8_substr_word($tmp,160).'...'; // if set, add link to this page as subpage $pages_top_arr[$zaznam['pid']] = printSqlCol('parentpage',$zaznam); // if this page == current -> set page type if ($zaznam['pid']==$homepage_id) { $page_type = ''; $page_top = printSqlCol('parentpage',$zaznam); if (isset($pages_top_arr[$page_top]) && $pages_top_arr[$page_top]>0) $page_top = $pages_top_arr[$page_top]; if (!$title) $title = printSqlCol('name',$zaznam); $perex = printSqlCol('preview',$zaznam); $text = printSqlCol('content',$zaznam); // found SEO data in db $title_seo = printSqlCol('name_title',$zaznam); $descr_seo = printSqlCol('preview_desc',$zaznam); } if ($zaznam['parentpage']==$homepage_id) { $i++; $homepage_title_arr[$i] = printSqlCol('name',$zaznam); $homepage_text_arr[$i] = printSqlCol('content',$zaznam); } // products based on pages (category) if ($zaznam['parentpage']==2 || $zaznam['parentpage']==3) { $products_page_cat_arr[$zaznam['pid']] = printSqlCol('parentpage',$zaznam); // images $tmp_arr = explode('|',printSqlCol('images',$zaznam)); $products_page_images_all_arr[] = $tmp_arr[0]; $products_page_images_arr[$zaznam['pid']] = $tmp_arr[0]; // count main products if (printSqlCol('parentpage',$zaznam)==3) { $products_izolace_count++; } else if (printSqlCol('parentpage',$zaznam)==2) { $products_filtrace_count++; } } } } else { // found url in db $sSql = "SELECT * FROM url WHERE url$lang_sql_str='$page_link'"; $vysledek = Pg_Exec($sSql); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { // page conf $page = printSqlCol('url'.$lang_sql_str,$zaznam); // in other language update col_name[X] $page_id = printSqlCol('item',$zaznam); $table = printSqlCol('tabulka',$zaznam); // links to other langs $page_url_arr = array('cz'=>$root.''.printSqlCol('url',$zaznam),'en'=>$root.'en/'.printSqlCol('url1',$zaznam),'de'=>$root.'de/'.printSqlCol('url2',$zaznam),'ru'=>$root.'ru/'.printSqlCol('url3',$zaznam)); // seo for cur. page in cur. lang $title_seo = printSqlCol('title'.$lang_sql_str,$zaznam); $descr_seo = printSqlCol('descr'.$lang_sql_str,$zaznam); } /* -------------------------------- all pages inc. category pages -------------------------------- */ // for all pages read products pages for top menu (cache?) $custommer_type = false; $vysledek = Pg_Exec("SELECT pdp_pages.realforms,pdp_pages.sellers,pdp_pages.images,pdp_pages.custommertype,pdp_pages.relatedprod,pdp_pages.files,pdp_pages.parentpage,pdp_pages.id AS pid,pdp_pages_text.* FROM pdp_pages,pdp_pages_text WHERE pdp_pages.id = pdp_pages_text.item AND pdp_pages_text.language = '$lang' AND pdp_pages.active = 1 ORDER BY razeni"); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { // if not set page icon use page title $ikona_tmp = printSqlCol('icon',$zaznam); $pages_arr[$zaznam['pid']] = $ikona_tmp!='' ? $ikona_tmp : printSqlCol('name',$zaznam); $pages_title_arr[$zaznam['pid']] = printSqlCol('name',$zaznam); $pages_url_arr[$zaznam['pid']] = $root.$language_link.printSqlCol('alias',$zaznam); // prepare perex if ($zaznam['pid']==$page_izolace_id || $zaznam['pid']==$page_filtrace_id || $zaznam['pid']==1) { $pages_perex_arr[$zaznam['pid']] = strip_tags(printSqlCol('preview',$zaznam)); } else { $tmp = strip_tags(printSqlCol('preview',$zaznam)).' '.strip_tags(printSqlCol('content',$zaznam)); $pages_perex_arr[$zaznam['pid']] = utf8_substr_word($tmp,160).'...'; } // if this page == current -> set page type if ($zaznam['pid']==$page_404_id) { $p404_text = printSqlCol('content',$zaznam); $p404obrazky = printSqlCol('images',$zaznam); $p404soubory = printSqlCol('files',$zaznam); $p404realforms = printSqlCol('realforms',$zaznam); } // products based on pages (category) if ($zaznam['parentpage']==2 || $zaznam['parentpage']==3 || $zaznam['parentpage']==4 || $zaznam['parentpage']==9) { $products_page_images_arr[$zaznam['pid']] = printSqlCol('images',$zaznam); $products_page_cat_arr[$zaznam['pid']] = printSqlCol('parentpage',$zaznam); // count main products if (printSqlCol('parentpage',$zaznam)==3) { $products_izolace_count++; } else if (printSqlCol('parentpage',$zaznam)==2) { $products_filtrace_count++; } // images $tmp_arr = explode('|',printSqlCol('images',$zaznam)); $products_page_images_all_arr[] = $tmp_arr[0]; $products_page_images_arr[$zaznam['pid']] = $tmp_arr[0]; } // if set, add link to this page as subpage $pages_top_arr[$zaznam['pid']] = printSqlCol('parentpage',$zaznam); // if this page == current -> set page type if ($table == 'pdp_pages_text' && $zaznam['pid']==$page_id) { $page_type = ''; $page_top = printSqlCol('parentpage',$zaznam); if (isset($pages_top_arr[$page_top]) && $pages_top_arr[$page_top]>0) $page_top = $pages_top_arr[$page_top]; if (!$title) $title = printSqlCol('name',$zaznam); $perex = printSqlCol('preview',$zaznam); $text = printSqlCol('content',$zaznam); $obrazky = printSqlCol('images',$zaznam); $soubory = printSqlCol('files',$zaznam); $realforms = printSqlCol('realforms',$zaznam); $produkt_prodejci = printSqlCol('sellers',$zaznam); // article products $produkty_arr = array(); if (printSqlCol('relatedprod',$zaznam)!='') $produkty_arr = explode('|',printSqlCol('relatedprod',$zaznam)); } } // product if ($table == 'pdp_products_text') { $vysledek = Pg_Exec("SELECT pdp_products.code, pdp_products.cat AS cat2, pdp_products.sellers, pdp_products.accessoriesprod, pdp_products.relatedprod, pdp_products.novinkado, pdp_products.doporucujeme, pdp_products.realforms, pdp_products.id AS pid, pdp_products.producer, pdp_products.files, pdp_products.images, pdp_products.url, pdp_products.prislusenstvi, pdp_products_text.* FROM pdp_products,pdp_products_text WHERE pdp_products.id = pdp_products_text.item AND pdp_products_text.language = '$lang' AND pdp_products.$sql_active AND pdp_products.id = '$page_id' ORDER BY id DESC LIMIT 20"); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { // main data $produkt = $title = printSqlCol('name',$zaznam); $produkt_url = $root.$language_link.printSqlCol('alias',$zaznam); $produkt_kategorie = printSqlCol('cat2',$zaznam); // product data $produkt_kod = printSqlCol('code',$zaznam); $produkt_eshop = printSqlCol('url',$zaznam); $produkt_novinkado = printSqlCol('novinkado',$zaznam); $produkt_doporucujeme = printSqlCol('doporucujeme',$zaznam); $produkt_realforms = printSqlCol('realforms',$zaznam); $produkt_prodejci = printSqlCol('sellers',$zaznam); $produkt_prislusenstvi_init = printSqlCol('prislusenstvi',$zaznam); $produkt_vyrobce = printSqlCol('producer',$zaznam); $produkt_perex = $perex = printSqlCol('preview',$zaznam); $produkt_text = $text = printSqlCol('content',$zaznam); $produkt_spec = printSqlCol('spec',$zaznam); // product array $obrazky = printSqlCol('images',$zaznam); $soubory = printSqlCol('files',$zaznam); $prislusenstvi = printSqlCol('accessoriesprod',$zaznam); $podobne = printSqlCol('relatedprod',$zaznam); } } // article if ($table == 'pdp_articles_text') { $vysledek = Pg_Exec("SELECT pdp_articles.expires,pdp_articles.realforms,pdp_articles.sellers,pdp_articles.relatedprod,pdp_articles.id AS pid,pdp_articles.files,pdp_articles.images,pdp_articles_text.* FROM pdp_articles,pdp_articles_text WHERE pdp_articles.id = pdp_articles_text.item AND pdp_articles_text.language = '$lang' AND pdp_articles.$sql_active AND pdp_articles.id = '$page_id'"); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { // main data $clanek = $title = printSqlCol('name',$zaznam); $clanek_url = $root.$language_link.printSqlCol('alias',$zaznam); // article data $clanek_prodejci = printSqlCol('sellers',$zaznam); $clanek_perex = $perex = printSqlCol('preview',$zaznam); $clanek_text = $text = printSqlCol('content',$zaznam); $realforms = printSqlCol('realforms',$zaznam); $produkt_prodejci = printSqlCol('sellers',$zaznam); $clanek_expires = printSqlCol('expires',$zaznam); // article files $obrazky = printSqlCol('images',$zaznam); $soubory = printSqlCol('files',$zaznam); // article products $clanek_produkty_arr = array(); if (printSqlCol('relatedprod',$zaznam)!='') $clanek_produkty_arr = explode('|',printSqlCol('relatedprod',$zaznam)); } } } // 404 error page if (!$page) { $table = 'pdp_pages_text'; $page_id = $page_404_id; $title = $pages_arr[$page_id]; $perex = $pages_perex_arr[$page_id]; $text = $p404_text; $produkty_arr = array(); $obrazky = $p404obrazky; $soubory = $p404soubory; $realforms = $p404realforms; $produkt_prodejci = ''; $breadcrumb = $title; } // sellers for pages,news,actions if ($produkt_prodejci && ($table == 'pdp_pages_text' || $table == 'pdp_articles_text')) { $produkt_prodejci_arr = explode('|',$produkt_prodejci); if (count($produkt_prodejci_arr)>0) { // sql $sellers_sql = ''; $sellers_sql = 'id='.implode(' OR id=',$produkt_prodejci_arr); $sellers_sql = ' AND ('.$sellers_sql.')'; //id,name,mail,phone,cz,sk $vysledek = Pg_Exec("SELECT * FROM pdp_products_sellers WHERE $sql_active$sellers_sql"); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $sellers_arr[$zaznam['id']] = ''.printSqlCol('name',$zaznam)."
\n".$telefon_text.': '.printSqlCol('phone',$zaznam)."
\n"."\n"; // .$email_text.': '.''.printSqlCol('mail',$zaznam).'' } } } // news $news = $table=='aktuality' || $page_id==$page_news_id ? true : false; // folder $inc_str = ''; // validate send form if ($get_e && $table == 'pdp_pages_text' && $page_id==251) { $data_formulare = $predmet = $email_to_bp = ''; $get_e = addslashes($get_e); $vysledek = Pg_Exec("SELECT * FROM tmp_emails WHERE code='$get_e' AND status='0'"); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $data_formulare = printSqlCol('content',$zaznam); $predmet = printSqlCol('title',$zaznam); $email_formulare = printSqlCol('email',$zaznam); $email_to_bp = printSqlCol('emailtobp',$zaznam) ? printSqlCol('emailtobp',$zaznam) : 'info@hobra.cz'; } // insert data to tmp table if ($data_formulare) { $sendcommand = "UPDATE tmp_emails SET status=1 WHERE code='$get_e' AND status='0'"; if (Pg_Exec($sendcommand)) { // petr.vrestiak@gmail.com, if(Mail("web.hobra@gmail.com",'Hobra Školník / '.$predmet,preg_replace_callback('/&#([0-9a-fx]+);/mi', 'replace_num_entity', html_entity_decode(stripslashes($data_formulare))),"From: $email_formulare\nContent-type:text/plain; charset=\"utf-8\"\nX-Mailer:PHP/" . phpversion())) { // print success info $odesilaci_hlaska = 'Děkujeme, Váš požadavek byl potvrzen a odeslán ke zpracování.'; $odesilaci_hlaska_typ = "correct"; } } else { $odesilaci_hlaska = 'Nepodařilo se potvrdit dotaz.
'; } } } // send contact form $odesilaci_hlaska = false; $jmeno = $email = $dotaz = ''; $aspm = isset($_POST['aspm']) && $_POST['aspm']!='' ? $_POST['aspm'] : false; if ($aspm) { // RESERVATION start $jmeno = GetOrPostSafe('jmeno','post','str'); $prijmeni = GetOrPostSafe('prijmeni','post','str'); $dotaz = GetOrPostSafe('dotaz','post','str'); $email = GetOrPostSafe('email','post','str'); $telefon = GetOrPostSafe('telefon','post','str'); $izolace = GetOrPostSafe('izolace','post','str'); $filtrace = GetOrPostSafe('filtrace','post','str'); // anti spam $my_code = 11 * SubStr(GetEnv('REMOTE_ADDR'),0,1); if(isset($_POST['akce']) && $_POST['akce'] == 'sendForm' && $aspm==$my_code) { // mail to first contact person $init = true; $email_to_bp = ''; if (isset($_POST['seller']) && $_POST['seller']>0) { $sendSellerID = GetOrPostSafe('seller','post','int'); $vysledek = Pg_Exec("SELECT mail FROM pdp_products_sellers WHERE id=$sendSellerID AND mail IS NOT NULL AND active=1"); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $email_to_bp = printSqlCol('mail',$zaznam); if ($email_to_bp) $init = false; } } else if (isset($produkt_prodejci_arr) && count($produkt_prodejci_arr)>0) { foreach ($produkt_prodejci_arr as $key => $value) { if ($init && $value>0) { // get first contact email $lang_sql = " AND $lang = 1"; $vysledek = Pg_Exec("SELECT mail FROM pdp_products_sellers WHERE id=$value AND mail IS NOT NULL AND active=1$lang_sql"); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $email_to_bp = printSqlCol('mail',$zaznam); if ($email_to_bp) $init = false; } } } } // global customer email nefunguje detekce mailu z db if ($email_to_bp=='') { $email_to_bp = 'info@hobra.cz'; } // if not send requiure data & print error if ( $email==$email_text || $dotaz==$dotaz_text || $jmeno==$jmeno_text) { $neodesilat = 'oki'; $odesilaci_hlaska = $odeslano_nok_text; // email must by valid for send confirmation url } else if (!CheckEmail($email)) { $neodesilat = 'oki'; $odesilaci_hlaska = $odeslano_nok_text; } else { $adresat1 = '...'; $adresat2 = 'petr.vrestiak@gmail.com'; $dnesni_datum = date("H:i m.d.y"); $predmet = 'Hobra Školník / dotaz ze stránek'; $odesilaci_email = $email_to_bp; // OLD GLOBAL MAIL 'info@hobra.'.$lang; // mail tmp id $mail_id = 1; /* $mail_id = Pg_Exec("SELECT nextval('tmp_emails_id_seq');"); $mail_id = Pg_Fetch_Array($mail_id,0); $mail_id = $mail_id['nextval']; */ // hash key for email validation $mail_key = md5(time().$mail_id); $url_formulare = $_SERVER['REQUEST_URI']; // make email $potvrzeni_formulare = ''; /*" Dobrý den, děkujeme za Vás dotaz a prosíme o potvrzení níže uvedených údajů, kliknutím na tento odkaz: http://www.hobra.cz/potvrzeni-zaslaneho-dotazu?e=".$mail_key." Vzhledem k platné legislativě nemůžeme bez kliknutí na potvrzující odkaz váš dotaz zpracovat. Děkujeme za pochopení Hobra s.r.o. Zde jsou Vaše kontaktní údaje a připravený dotaz: --------------------------------------------------------------"; */ $data_formulare = " $jmeno_text: $jmeno $email_text: $email Oblast: $izolace $filtrace -------------------------------------------------------------- $vas_dotaz_text: $dotaz Ze stránky: $url_formulare"; } // insert data to tmp table if ($data_formulare) { /* $sendcommand = "INSERT INTO tmp_emails (id,datumzadani,emailtobp,content,title,email,url,status,code,lang) VALUES ("; $sendcommand .= "'".AddSlashes($mail_id)."',"; $sendcommand .= "CURRENT_TIMESTAMP,"; $sendcommand .= "'".AddSlashes($email_to_bp)."',"; $sendcommand .= "'".AddSlashes($data_formulare)."',"; $sendcommand .= "'".AddSlashes($title)."',"; $sendcommand .= "'".AddSlashes($email)."','".AddSlashes($url_formulare)."',0,'".AddSlashes($mail_key)."','".AddSlashes($lang)."')"; $sendcommand = str_replace("''","NULL",$sendcommand); */ //if (Pg_Exec($sendcommand)) { /* old sender email new seller email $odesilaci_email */ // if(Mail('web.hobra@gmail.com',$predmet,$potvrzeni_formulare.preg_replace_callback('/&#([0-9a-fx]+);/mi', 'replace_num_entity', html_entity_decode(stripslashes($data_formulare))),"From: $email_to_bp\nContent-type:text/plain; charset=\"utf-8\"\nX-Mailer:PHP/" . phpversion())) { //Mail($email_to_bp,$predmet,$potvrzeni_formulare.preg_replace_callback('/&#([0-9a-fx]+);/mi', 'replace_num_entity', html_entity_decode(stripslashes($data_formulare))),"From: $email_to_bp\nContent-type:text/plain; charset=\"utf-8\"\nX-Mailer:PHP/" . phpversion()) // DOCASNE!!! - bez kontroly //Mail('petr.vrestiak@gmail.com',$predmet,$potvrzeni_formulare.preg_replace_callback('/&#([0-9a-fx]+);/mi', 'replace_num_entity', html_entity_decode(stripslashes($data_formulare))),"From: $email_to_bp\nContent-type:text/plain; charset=\"utf-8\"\nX-Mailer:PHP/" . phpversion()) // print success info $odesilaci_hlaska = $odeslano_ok_text; $odesilaci_hlaska_typ = "correct"; } else { // print error info $odesilaci_hlaska = $odeslano_nok_text; } // clear contacts $jmeno = $email = $dotaz = ''; /* } else { $odesilaci_hlaska = $odeslano_nok_text; } */ } } } $page_section = $table=='pdp_products_cat_text' ? '' : ''; // detect main class 'izolace', 'filtrace', 'other' $main_class = 'other'; $top_page_title = ''; // clasic pages if ($table == 'pdp_pages_text') { // filtrace if ($page_id==45 || (isset($pages_top_arr[$page_id]) && $pages_top_arr[$page_id]==45) || $page_id==$page_filtrace_id || (isset($pages_top_arr[$page_id]) && $pages_top_arr[$page_id]==$page_filtrace_id) || $page_id==$page_aplication_filtrace_id || (isset($pages_top_arr[$page_id]) && $pages_top_arr[$page_id]==$page_aplication_filtrace_id)) { $main_class = 'filtrace'; } // izolace if ($page_id==$page_izolace_id || (isset($pages_top_arr[$page_id]) && $pages_top_arr[$page_id]==$page_izolace_id) || $page_id==$page_aplication_izolace_id || (isset($pages_top_arr[$page_id]) && $pages_top_arr[$page_id]==$page_aplication_izolace_id)) { $main_class = 'izolace'; } // breadcrumb // 1.st level $breadcrumb = $top_page_title = $title; $tmp_breadcrumb = false; // 2.st level if (isset($pages_top_arr[$page_id]) && $pages_top_arr[$page_id]>0) { $tmp_breadcrumb = $pages_top_arr[$page_id]; $breadcrumb = ''.$pages_arr[$pages_top_arr[$page_id]].' > '.$breadcrumb.''; $top_page_title = $pages_title_arr[$pages_top_arr[$page_id]]; } // 3.st level if (isset($pages_top_arr[$tmp_breadcrumb]) && $pages_top_arr[$tmp_breadcrumb]>0) { $tmp_breadcrumb = $pages_top_arr[$tmp_breadcrumb]; $breadcrumb = ''.$pages_arr[$tmp_breadcrumb].' > '.$breadcrumb; $top_page_title = $pages_title_arr[$tmp_breadcrumb]; } // 4.st level if (isset($pages_top_arr[$tmp_breadcrumb]) && $pages_top_arr[$tmp_breadcrumb]>0) { $tmp_breadcrumb = $pages_top_arr[$tmp_breadcrumb]; $breadcrumb = ''.$pages_arr[$tmp_breadcrumb].' > '.$breadcrumb; $top_page_title = $pages_title_arr[$tmp_breadcrumb]; } } else if ($table == 'pdp_products_text') { // breadcrumb $cat_id = $produkt_kategorie; // filtrace if ($cat_id==$page_filtrace_id || (isset($pages_top_arr[$cat_id]) && $pages_top_arr[$cat_id]==$page_filtrace_id)) { $main_class = 'filtrace'; } // izolace if ($cat_id==$page_izolace_id || (isset($pages_top_arr[$cat_id]) && $pages_top_arr[$cat_id]==$page_izolace_id)) { $main_class = 'izolace'; } // 1.st level $breadcrumb = $top_page_title = $title; $tmp_breadcrumb = false; /* echo $cat_id.' / '; print_r($pages_arr); print_r($pages_top_arr); */ // 2.st level if (isset($pages_arr[$cat_id]) && $pages_arr[$cat_id]) { $tmp_breadcrumb = $cat_id; $breadcrumb = ''.$pages_arr[$cat_id].' > '.$breadcrumb.''; $top_page_title = $pages_title_arr[$cat_id]; } // 3.st level if (isset($pages_top_arr[$tmp_breadcrumb]) && $pages_top_arr[$tmp_breadcrumb]>0) { $tmp_breadcrumb = $pages_top_arr[$tmp_breadcrumb]; $breadcrumb = ''.$pages_arr[$tmp_breadcrumb].' > '.$breadcrumb; $top_page_title = $pages_title_arr[$tmp_breadcrumb]; } // 4.st level if (isset($pages_top_arr[$tmp_breadcrumb]) && $pages_top_arr[$tmp_breadcrumb]>0) { $tmp_breadcrumb = $pages_top_arr[$tmp_breadcrumb]; $breadcrumb = ''.$pages_arr[$tmp_breadcrumb].' > '.$breadcrumb; $top_page_title = $pages_title_arr[$tmp_breadcrumb]; } } /* ----------------- all banners ----------------- */ $banners_left_arr = $banners_slideshow_arr = $banners_url_arr = $banners_pcs_arr = $banners_type_arr = $banners_text_arr = $banners_typ_arr = array(); $today = date('Y-m-d'); $banners_folder = $root.'data/banners/'; $banners_first = false; $vysledek = Pg_Exec("SELECT pdp_banners.typ,pdp_banners.izolace,pdp_banners.filtrace,pdp_banners.ofirme,pdp_banners.soubor,pdp_banners.id,pdp_banners_text.content,pdp_banners_text.preview,pdp_banners_text.name,pdp_banners_text.link FROM pdp_banners,pdp_banners_text WHERE pdp_banners.id = pdp_banners_text.item AND pdp_banners_text.language = '$lang' AND pdp_banners.active = 1 AND pdp_banners.datumod <= '$today' AND pdp_banners.datumdo >= '$today' ORDER BY pdp_banners.razeni"); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { if (($zaznam['izolace']=='t' && $main_class=='izolace') || ($zaznam['filtrace']=='t' && $main_class=='filtrace') || ($zaznam['ofirme']=='t' && $main_class=='other')) { $banners_slideshow_arr[$zaznam['id']] = printSqlCol('name',$zaznam); $banners_typ_arr[$zaznam['id']] = printSqlCol('typ',$zaznam); $banners_url_arr[$zaznam['id']] = printSqlCol('link',$zaznam); $banners_pcs_arr[$zaznam['id']] = printSqlCol('soubor',$zaznam); $banners_text_arr[$zaznam['id']] = nl2br(printSqlCol('preview',$zaznam)); // cilovky if ($zaznam['ofirme']=='t') $banners_color_arr[$zaznam['id']] = 'other'; if ($zaznam['izolace']=='t') $banners_color_arr[$zaznam['id']] = 'izolace'; if ($zaznam['filtrace']=='t') $banners_color_arr[$zaznam['id']] = 'filtrace'; } } /* ----------------- news ----------------- */ $news_arr = $news_text_arr = $news_color_arr = $news_foto_arr = $news_foto_all_arr = array(); $vysledek = Pg_Exec("SELECT pdp_articles.*,pdp_articles_text.name,pdp_articles_text.content,pdp_articles_text.alias FROM pdp_articles,pdp_articles_text WHERE pdp_articles.id = pdp_articles_text.item AND pdp_articles_text.language = '$lang' AND pdp_articles.active = 1 AND expires IS NULL ORDER BY pdp_articles.id DESC"); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $news_arr[$zaznam['id']] = printSqlCol('name',$zaznam); $news_text_arr[$zaznam['id']] = printSqlCol('content',$zaznam); if (printSqlCol('images',$zaznam)) { $tmp_arr = explode('|',printSqlCol('images',$zaznam)); $news_foto_arr[$zaznam['id']] = $tmp_arr[0]; $news_foto_all_arr[] = $tmp_arr[0]; } // cilovky if ($zaznam['ofirme']=='t') $news_color_arr[$zaznam['id']] = 'other'; if ($zaznam['izolace']=='t') $news_color_arr[$zaznam['id']] = 'izolace'; if ($zaznam['filtrace']=='t') $news_color_arr[$zaznam['id']] = 'filtrace'; } ?> Hobra.cz - <? echo $title_seo!='' ? $title_seo : $title ?>

$value) { if (isset($news_color_arr[$key]) && $news_color_arr[$key]=='filtrace' && $i<1) { $i++; ?>

$value) { if (isset($news_color_arr[$key]) && $news_color_arr[$key]=='izolace' && $i<1) { $i++; // " style="background-image: url($filepath_arr[$news_foto_arr[$key]] ?>

Home >

  • $value) { //produkt_pcs_arr if (($value==$page_filtrace_id && $main_class=='filtrace') || ($value==$page_izolace_id && $main_class=='izolace')) { // detect if are low products $submenu = in_array($key,$products_cat_arr) ? 'submenu' : ''; ?>
    • $value2) { //products_cat_arr (page_id in value) if (($value2==$page_id && $table=='pdp_pages_text') || (isset($cat_id) && $cat_id==$value2)) { if ($page_id==$key2 && $table=='pdp_products_text') { ?>
  • $value) { //products_cat_arr (page_id in value) if (($value==$page_filtrace_id && $main_class=='filtrace') || ($value==$page_izolace_id && $main_class=='izolace')) { if ($page_id==$key && $table=='pdp_products_text') { ?>
  • $value) { if (($main_class=='izolace' && $value==$page_aplication_izolace_id) || ($main_class=='filtrace' && $value==$page_aplication_filtrace_id)) { if ($page_id==$key) { ?>
    > $value) { //produkt_pcs_arr if (($value==$page_top && $page_top>0) || (!$page_top && $pages_top_arr[$key]==$page_id)) { ?> >
  • $value) { if ($value==45) { if ($page_id==$key && $table=='pdp_pages_text') { ?>
$value) { if (isset($news_color_arr[$key]) && $news_color_arr[$key]!='') { // default hide $show = false; if ($news_color_arr[$key]=='filtrace' && $filtrace_n<1) { $filtrace_n++; $show = true; } if ($news_color_arr[$key]=='izolace' && $izolace_n<1) { $izolace_n++; $show = true; } if ($news_color_arr[$key]=='other' && $other_n<1) { $other_n++; $show = true; } if ($show) { ?>


>

$value) { // bottom slideshow banners if ($value==2) { $i++; $active = $i==1 ? ' active' : ''; ?>

<? echo $banners_slideshow_arr[$key] ?>

0) $images_search_sql .= ' OR '; if (count($produkty_pcs_arr)>0) $images_search_sql .= 'id='.implode(' OR id=',$produkty_pcs_arr); // pages if ($images_search_sql!='' && count($pages_search_pcs_arr)>0) $images_search_sql .= ' OR '; if (count($pages_search_pcs_arr)>0) $images_search_sql .= 'id='.implode(' OR id=',$pages_search_pcs_arr); // articles if ($images_search_sql!='' && count($articles_search_pcs_arr)>0) $images_search_sql .= ' OR '; if (count($articles_search_pcs_arr)>0) $images_search_sql .= 'id='.implode(' OR id=',$articles_search_pcs_arr); if ($images_search_sql!='') $images_search_sql = '('.$images_search_sql.')'; // archive $filepath_arr = $filepath_big_arr = $pano_pcs_arr = array(); if ($images_search_sql!='') { //echo ''; $vysledek = Pg_Exec("SELECT * FROM pdp_lib_images WHERE $images_search_sql"); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $id2 = $zaznam['id']; $filepath = isset($zaznam['file']) && $zaznam['file']!='' ? $root.$conf_path_to_gallery.$conf_images_folder.$id2[0].'/s-'.StripSlashes($zaznam['file']) : $root.'data/imgs/'.sprintf('%05d', $zaznam['id']).'m.jpg'; // file = 03605s.jpg http://www.hobra.cz $filepath_big = isset($zaznam['file']) && $zaznam['file']!='' ? $root.$conf_path_to_gallery.$conf_images_folder.$id2[0].'/'.StripSlashes($zaznam['file']) : $root.'data/imgs/'.sprintf('%05d', $zaznam['id']).'l.jpg'; // file = 03605s.jpg // add panorama/ultrawide class if (isset($zaznam['dimensions']) && $zaznam['dimensions']!='') { $tmp_dimensions_arr = explode('-',$zaznam['dimensions']); // 180 / 100 if ($tmp_dimensions_arr[0]=='w' && $tmp_dimensions_arr[1] / $tmp_dimensions_arr[2] > 1.8) { $pano_pcs_arr[$id2] = true; } } // add data to image arr $filepath_arr[$id2] = $filepath; $filepath_big_arr[$id2] = $filepath; } } ?>

4 || $nalezeno===0 ? $zaznamu_text : ($nalezeno>1 ? $zaznamy_text : $zaznam_text) ?>.

$value) { $i++; ?>

' ?>

$value) { $i++; ?>

$value) { $i++; ?>

0) { ?>

:
$value) { ?>


$value) { //produkt_pcs_arr if (isset($products_application_arr[$key]) && in_array($page_id,$products_application_arr[$key])) { $i++; $m++; ?>

' ?>

:
0) { foreach ($products_application_arr[$key] as $key2 => $value2) { $n++; ?>

0) { ?>

:
$value) { ?>


$value) { //produkt_pcs_arr if ($pages_top_arr[$key]==$page_id && ($pages_top_arr[$key]==$page_izolace_id || $pages_top_arr[$key]==$page_filtrace_id || $pages_top_arr[$key]==$page_aplication_izolace_id || $pages_top_arr[$key]==$page_aplication_filtrace_id)) { $i++; $m++; ?>

$value) { //produkt_pcs_arr if ($value==$page_id) { $i++; $m++; ?>

' ?>

:
0) { foreach ($products_application_arr[$key] as $key2 => $value2) { $n++; ?>

$value) { // first id if (!$first_id) { $first_id = $key; $tmp = $key; // 1st rec. ID // next rec. id } else { $news_prev_arr[$tmp] = $key; $tmp = $key; } } ?>


$value) { $i++; ?>


0) { // archive images $file_name_arr = $filepath_arr = $filepath_big_arr = $image_rec_title_arr = array(); $first_img = false; if ($obrazky!='') { $tmp_arr = $pcs_order_arr = explode('|',$obrazky); GetImagesArr($tmp_arr); // update img. arr. $first_img = isset($filepath_big_arr[$tmp_arr[0]]) ? $filepath_big_arr[$tmp_arr[0]] : false; $first_title_img = isset($image_rec_title_arr[0]) ? $image_rec_title_arr[0] : ''; } ?>

' ?>
0) { $tmp_arr = array_reverse($products_application_arr[$page_id]); foreach ($tmp_arr as $key => $value) { ?>

0) { ?>

:
$value) { ?>

:
0) { foreach ($products_application_arr[$page_id] as $key => $value) { ?>

0) { ?>

:
$value) { ?>

0) { // archive images $file_name_arr = $filepath_arr = $filepath_big_arr = $image_rec_title_arr = array(); $first_img = false; if ($obrazky!='') { $tmp_arr = $pcs_order_arr = explode('|',$obrazky); GetImagesArr($tmp_arr); // update img. arr. $first_img = isset($filepath_big_arr[$tmp_arr[0]]) ? $filepath_big_arr[$tmp_arr[0]] : false; $first_title_img = isset($image_rec_title_arr[0]) ? $image_rec_title_arr[0] : ''; } ?>

'; echo PrintContacts($tmp_arr); } ?> 0) { ?>

:
$value) { ?>

0) { ?>






$value) { // bottom slideshow banners if ($value==1) { $i++; $active = $i==1 ? ' active' : ''; $switches .= '•'."\n"; ?>

: